﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ZhimeiSoft.Framework.Server.Connector.DAL
{
    public static class UserDal_Const
    {

        public static string SQL_SELECT_GETALLUSERS = "SELECT * FROM TUsers";

        public static string SQL_INSERT_INSERTUSER = "INSERT INTO TUsers (UserID, UserName, Password, DisplayName) VALUES (@UserID, @UserName, @Password, @DisplayName)";

        public static string SQL_UPDATE_UPDATEUSER = "UPDATE TUsers SET UserName=@UserName, Password=@Password, DisplayName=@DisplayName WHERE UserID=@UserID";

        public static string SQL_DELETE_DELETEUSER = "DELETE FROM TUsers WHERE UserID=@UserID";

    }
}
